﻿<html xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:mshelp="http://msdn.microsoft.com/mshelp" xmlns:mshelp="http://msdn.microsoft.com/mshelp" xmlns:ddue="http://ddue.schemas.microsoft.com/authoring/2003/5" xmlns:msxsl="urn:schemas-microsoft-com:xslt">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    
    <meta name="save" content="history" />
    <meta name="Language" content="en-us" />
    <meta name="Microsoft.Help.Id" content="ada4926d-5e2b-4a17-b651-60684e4d72cd" />
    <meta name="Description" content="The Build Status report helps the team track the progress of their builds by showing the number of builds that failed or succeeded for the most recent four weeks." />
    <meta name="Microsoft.Help.ContentType" content="Concepts" />
    <meta name="DCSext.ProductFamily" content="LIB_DG" />
    <meta name="DCSext.Product" content="ALM_TeamFoundation" />
    <meta name="DCSext.Title" value="Builds Status Excel Report" />
    <link rel="stylesheet" type="text/css" href="../styles/presentation.css" />
    
    <script type="text/javascript" src="../scripts/EventUtilities.js"> </script>
    <script type="text/javascript" src="../scripts/SplitScreen.js"> </script>
    <script type="text/javascript" src="../scripts/Dropdown.js"> </script>
    <script type="text/javascript" src="../scripts/script_manifold.js"> </script>
    <script type="text/javascript" src="../scripts/script_feedBack.js"> </script>
    <script type="text/javascript" src="../scripts/CheckboxMenu.js"> </script>
    <script type="text/javascript" src="../scripts/CommonUtilities.js"> </script>
    <xml><mshelp:toctitle Title="Builds Status" /><mshelp:keyword Index="A" Term="ada4926d-5e2b-4a17-b651-60684e4d72cd" /><mshelp:attr Name="RevisionNumber" Value="9" /><mshelp:attr Name="AssetID" Value="ada4926d-5e2b-4a17-b651-60684e4d72cd" /><mshelp:attr Name="Abstract" Value="The Build Status report helps the team track the progress of their builds by showing the number of builds that failed or succeeded for the most recent four weeks." /><mshelp:attr Name="CommunityContent" Value="1" /><mshelp:attr Name="ShippedIn" Value="vs.90" /><mshelp:attr Name="TopicVersion" Value="10.0.10236.10000" /><mshelp:attr Name="Catalog Container" Value="System_Default_Catalog" /><mshelp:attr Name="Content Set Container" Value="System_Default_Content_Set" /><mshelp:attr Name="TopicType" Value="kbArticle" /><mshelp:attr Name="Locale" Value="en-us" /></xml>
    <title>Builds Status Excel Report</title>
</head>
<body>
	<input type="hidden" id="userDataCache" class="userDataStyle" />
	<input type="hidden" id="hiddenScrollOffset" />
	<img id="collapseImage" style="display:none; height:0; width:0;" src="../icons/collapse_all.gif" alt="Collapse image" title="Collapse image" />
	<img id="expandImage" style="display:none; height:0; width:0;" src="../icons/expand_all.gif" alt="Expand Image" title="Expand Image" />
	<img id="collapseAllImage" style="display:none; height:0; width:0;" src="../icons/collapse_all.gif" />
	<img id="expandAllImage" style="display:none; height:0; width:0;" src="../icons/expand_all.gif" />
	<img id="dropDownImage" style="display:none; height:0; width:0;" src="../icons/dropdown.gif" />
	<img id="dropDownHoverImage" style="display:none; height:0; width:0;" src="../icons/dropdownHover.gif" />
	<img id="copyImage" style="display:none; height:0; width:0;" src="../icons/copycode.gif" alt="Copy image" title="Copy image" />
	<img id="copyHoverImage" style="display:none; height:0; width:0;" src="../icons/copycodeHighlight.gif" alt="CopyHover image" title="CopyHover image" />
	<div id="header">
		<table id="topTable" cellspacing="0" cellpadding="0">
			<tr>
				<td>
					<span onclick="ExpandCollapseAll(toggleAllImage)" style="cursor:default;" onkeypress="ExpandCollapseAll_CheckKey(toggleAllImage, event)" tabindex="0">
						<img ID="toggleAllImage" class="toggleAll" src="../icons/collapse_all.gif" /> 
						<label id="collapseAllLabel" for="toggleAllImage" style="display: none;">Collapse All</label>
						<label id="expandAllLabel" for="toggleAllImage" style="display: none;">Expand All</label> 
					</span> 
					<span>    </span> 
					<span id="devlangsDropdown" class="filter" tabindex="0">
						<img id="devlangsDropdownImage" src="../icons/dropdown.gif" /> 
						<label id="devlangsMenuAllLabel" for="devlangsDropdownImage" style="display: none;"><nobr>Code: All </nobr></label>
						<label id="devlangsMenuMultipleLabel" for="devlangsDropdownImage" style="display: none;"><nobr>Code: Multiple </nobr></label>
						<label id="devlangsMenuVisualBasicLabel" for="devlangsDropdownImage" style="display: none;"><nobr>Code: Visual Basic </nobr></label>
						<label id="devlangsMenuCSharpLabel" for="devlangsDropdownImage" style="display: none;"><nobr>Code: C# </nobr></label>
						<label id="devlangsMenuManagedCPlusPlusLabel" for="devlangsDropdownImage" style="display: none;"><nobr>Code: Visual C++ </nobr></label>
						<label id="devlangsMenuFSharpLabel" for="devlangsDropdownImage" style="display: none;"><nobr>Code: F# </nobr></label>
						<label id="devlangsMenuJScriptLabel" for="devlangsDropdownImage" style="display: none;"><nobr>Code: JScript </nobr></label>
					</span> 
				</td>
			</tr>
		</table>
		<div id="devlangsMenu">
			<input id="VisualBasicCheckbox" type="checkbox" data="VisualBasic,vb,'persist'" value="on" onClick="SetLanguage(this)" />
			<label class="checkboxLabel" for="VisualBasicCheckbox">Visual Basic</label><br />
			<input id="CSharpCheckbox" type="checkbox" data="CSharp,cs,'persist'" value="on" onClick="SetLanguage(this)" />
			<label class="checkboxLabel" for="CSharpCheckbox">C#</label><br />
			<input id="ManagedCPlusPlusCheckbox" type="checkbox" data="ManagedCPlusPlus,cpp,'persist'" value="on" onClick="SetLanguage(this)" />
			<label class="checkboxLabel" for="ManagedCPlusPlusCheckbox">Visual C++</label><br />
			<input id="FSharpCheckbox" type="checkbox" data="FSharp,fs,'persist'" value="on" onClick="SetLanguage(this)" />
			<label class="checkboxLabel" for="FSharpCheckbox">F#</label><br />
			<input id="JScriptCheckbox" type="checkbox" data="JScript,cs,'persist'" value="on" onClick="SetLanguage(this)" />
			<label class="checkboxLabel" for="JScriptCheckbox">JScript</label><br />
		</div>
		<table id="bottomTable" cellpadding="0" cellspacing="0">
			<tr id="headerTableRow1">
				<td align="left">
					<span id="runningHeaderText"> </span> 
				</td>
			</tr>
			<tr id="headerTableRow2">
				<td align="left">
					<span id="nsrTitle">Build Status Excel Report</span> 
				</td>
			</tr>
			<tr id="headerTableRow3">
				<td align="left">
					<span id="headfeedbackarea" class="feedbackhead">
						<a href="javascript:SubmitFeedback('bjordan@microsoft.com','','','10.0','10.0.10236.10000','%0\dThank%20you%20for%20your%20feedback.%20The%20GovDev%20team%20uses%20your%20feedback%20to%20improve%20documentation.%20While%20we%20are%20reviewing%20your%20feedback,%20we%20may%20send%20you%20e-mail%20to%20ask%20for%20clarification%20or%20feedback%20on%20a%20solution.%20We%20do%20not%20use%20your%20e-mail%20address%20for%20any%20other%20purpose%20and%20we%20delete%20it%20after%20we%20finish%20our%20review.%0\AFor%20further%20information%20about%20the%20privacy%20policies%20of%20Microsoft,%20please%20see%20http://privacy.microsoft.com/en-us/default.aspx.%0\A%0\d','Customer%20Feedback');">
							Send Feedback
						</a>
					</span> 
				</td>
			</tr>
		</table>
		<table id="gradientTable">
			<tr>
				<td class="nsrBottom" background="../icons/gradient.gif" />
			</tr>
		</table>
	</div>
    <div id="mainSection">
        <div id="mainBody">
            <div id="allHistory" class="saveHistory" onsave="saveAll()" onload="loadAll()" />
            <font color="DarkGray"><p /></font>
            <div class="introduction">
                <p>The Build Status report helps the team track the progress of their builds by showing
                    the number of builds that failed or succeeded for the most recent four weeks.
                </p>
                <p>For information about how to access this report, see <span sdata="link">
                    <a href="ExcelReportsGovDev.html">
                    Excel Reports (GovDev)</a></span>. </p>
                <div class="alert">
                    <table width="100%" cellspacing="0" cellpadding="0">
                        <tr>
                            <th align="left">
                                <img class="note" alt="Note" title="Note" src="../icons/alert_note.gif" /><b>Note
                                </b></th>
                        </tr>
                        <tr>
                            <td>
                                <p>You can view the Build Status report from the Quality dashboard. You can access this
                                    dashboard only if your team project portal has been enabled and is provisioned to
                                    use Microsoft Office SharePoint Server 2007. For more information, see <span sdata="link">
                                        <a href="http://msdn.microsoft.com/library/644ee4b7-3653-4943-9809-3d14d4d79c48">Access
                                            a Team Project Portal and Process Guidance</a></span>. </p>
                            </td>
                        </tr>
                    </table>
                </div>
                <div class="caption"></div>
                <div class="tableSection">
                    <table width="50%" cellspacing="2" cellpadding="5" frame="lhs">
                        <tr>
                            <td>
                                <p><span class="label">In this topic</span> </p>
                                <ul>
                                    <li>
                                        <p><a href="#Data">Data in the Report</a></p>
                                    </li>
                                    <li>
                                        <p><a href="#Interpreting">Interpreting the Report</a></p>
                                    </li>
                                    <li>
                                        <p><a href="#Updating">Customizing the Report</a></p>
                                    </li>
                                </ul>
                            </td>
                            <td>
                                <p><span class="label">Related topics</span> </p>
                                <ul>
                                    <li>
                                        <p><span sdata="link"><a href="QualityDashboardGovDev.html">Quality Dashboard (GovDev)
                                            </a></span> </p>
                                    </li>
                                    <li>
                                        <p><span sdata="link"><a href="BuildQualityIndicatorsReport.html">Build Quality Indicators
                                            Report</a></span> </p>
                                    </li>
                                </ul>
                            </td>
                        </tr>
                    </table>
                </div>
                <p><span class="label">Required Permissions</span> </p>
                <p>To view the report, you must be assigned or belong to a group that has been assigned
                    the <span class="ui">Read</span> permissions in SharePoint Products for the team
                    project. </p>
                <p>To modify or customize the report, you must be a member of the <span class="ui">TfsWarehouseDataReaders
                    </span> security role in SQL Server Analysis Services. You must also be assigned
                    or belong to a group that has been assigned the <span class="ui">Members</span> permissions
                    in SharePoint Products for the team project. For more information, see <span sdata="link">
                        <a href="http://msdn.microsoft.com/library/c7488754-77af-4fb4-8eca-1af0d206c9c8">Grant
                            Access to the Databases of the Data Warehouse for Visual Studio ALM</a></span> 
                    and <span sdata="link"><a href="http://msdn.microsoft.com/library/8f1f5f39-ed0f-4539-bee1-7e7e77bb5728">
                        Managing Permissions</a></span>. </p>
            </div>
            <a name="Data" />
            <h1 class="heading"><span onclick="ExpandCollapse(sectionToggle0)" style="cursor: default;"
                onkeypress="ExpandCollapse_CheckKey(sectionToggle0, event)" tabindex="0">
                <img id="sectionToggle0" class="toggle" name="toggleSwitch" src="../icons/collapse_all.gif" />Data
                in the Report</span> </h1>
            <div id="sectionSection0" class="section" name="collapseableSection" style="">
                <p>The team can review the Build Status report to help determine the trend of build
                    health over time and whether any builds need attention today. As the following illustration
                    shows, the report provides a stacked column of the number of builds that were run
                    with an outcome of failed, passed, or unknown during the most recent two weeks.
                </p>
                <img alt="Build Status report" src="../art/ProcGuid_AgileExcel.png" /><p>The chart is
                    based on a PivotTable from data that is stored in the Analysis Services database.
                </p>
                <h3 class="subHeading">Required Activities for Tracking Build Status</h3>
                <div class="subsection">
                    <p>For the Build Status report to be useful and accurate, the team must perform the
                        following activities: </p>
                    <ul>
                        <li>
                            <p><span class="label">Configure a build system</span>. To use Team Foundation Build,
                                you must set up a build system. </p>
                            <p>For more information, see <span sdata="link"><a href="http://msdn.microsoft.com/library/e5a1f360-7c62-44fc-8823-c6ebcd62bc20">
                                Configure Your Build System</a></span>.</p>
                        </li>
                        <li>
                            <p><span class="label">Create build definitions</span>. You can create several build
                                definitions and then run each of them to produce code for a different platform.
                                Also, you can run each build definition for a different configuration.</p>
                            <p>For more information, see <span sdata="link"><a href="http://msdn.microsoft.com/library/61593e10-d24b-492f-b19a-af4d85abea6b">
                                Creating and Working with Build Definitions</a></span>.</p>
                        </li>
                        <li>
                            <p><span class="label">Run builds regularly</span>. You can run builds at set intervals
                                or after every check-in. You can create regular builds when you use the schedule
                                trigger.</p>
                            <p>For more information, see <span sdata="link"><a href="http://msdn.microsoft.com/library/1c2eca2d-9a65-477e-9b23-0678ff7882ee">
                                Create a Basic Build Definition</a></span> and <span sdata="link"><a href="http://msdn.microsoft.com/library/5b8d6647-938a-4f7b-a72b-0f1921af849f">
                                    Running and Monitoring Builds</a></span>.</p>
                            <div class="alert">
                                <table width="100%" cellspacing="0" cellpadding="0">
                                    <tr>
                                        <th align="left">
                                            <img class="note" alt="Note" title="Note" src="../icons/alert_note.gif" /><b>Note
                                            </b></th>
                                    </tr>
                                    <tr>
                                        <td>
                                            <p>Although a team member can manually rate a build by using Build Explorer, this rating
                                                is not reflected in the Build Quality Indicators report. The build rating appears
                                                in the Build Summary report. For more information, see <span sdata="link"><a href="http://msdn.microsoft.com/library/fa9e34bb-8142-46e3-8bea-c4909a10e2bf">
                                                    Rate the Quality of a Completed Build</a></span> and <span sdata="link"><a href="BuildSummaryReport.html">
                                                        Build Summary Report</a></span>.</p>
                                        </td>
                                    </tr>
                                </table>
                            </div>
                        </li>
                    </ul>
                </div>
            </div>
            <a name="Interpreting" />
            <h1 class="heading"><span onclick="ExpandCollapse(sectionToggle1)" style="cursor: default;"
                onkeypress="ExpandCollapse_CheckKey(sectionToggle1, event)" tabindex="0">
                <img id="sectionToggle1" class="toggle" name="toggleSwitch" src="../icons/collapse_all.gif" />Interpreting
                the Report</span> </h1>
            <div id="sectionSection1" class="section" name="collapseableSection" style="">
                <p>You can use the Builds Status report to gain insight into the following questions:
                </p>
                <ul>
                    <li>
                        <p>How is my team's build health changing over time?</p>
                    </li>
                    <li>
                        <p>Do any builds need attention today?</p>
                    </li>
                </ul>
            </div>
            <a name="Updating" />
            <h1 class="heading"><span onclick="ExpandCollapse(sectionToggle2)" style="cursor: default;"
                onkeypress="ExpandCollapse_CheckKey(sectionToggle2, event)" tabindex="0">
                <img id="sectionToggle2" class="toggle" name="toggleSwitch" src="../icons/collapse_all.gif" />Customizing
                the Report</span> </h1>
            <div id="sectionSection2" class="section" name="collapseableSection" style="">
                <p>You can customize the Builds Status report by opening it in Office Excel and changing
                    the filter options or a column field list for the PivotTable report. You can modify
                    the report to support other views, as the following table describes.</p>
                <div class="caption"></div>
                <div class="tableSection">
                    <table width="50%" cellspacing="2" cellpadding="5" frame="lhs">
                        <tr>
                            <th>
                                <p>View</p>
                            </th>
                            <th>
                                <p>Action</p>
                            </th>
                        </tr>
                        <tr>
                            <td>
                                <p>Build results for an iteration</p>
                            </td>
                            <td>
                                <p>Change the filter for <b>WorkItem.Iteration</b>(default=All)</p>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                <p>Build results for a product area</p>
                            </td>
                            <td>
                                <p>Change the filter for <b>WorkItem.Area</b>(default=All)</p>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                <p>Build results for the most recent six, eight, or more weeks</p>
                            </td>
                            <td>
                                <p>In the Columns PivotTable Field List, replace <b>@@Last 4 weeks@@</b>with a different
                                    <b>Set</b></p>
                            </td>
                        </tr>
                    </table>
                </div>
                <p>For more information about how to work with and customize PivotTable and PivotChart
                    reports, see the following pages on the Microsoft Web site:</p>
                <ul>
                    <li>
                        <p><a href="http://go.microsoft.com/fwlink/?LinkId=165722">Ways to customize PivotTable
                            reports</a></p>
                    </li>
                    <li>
                        <p><a href="http://go.microsoft.com/fwlink/?LinkId=165723">Edit or remove a workbook
                            from Excel Services</a></p>
                    </li>
                    <li>
                        <p><a href="http://go.microsoft.com/fwlink/?LinkId=165724">Publish a workbook to Excel
                            Services</a></p>
                    </li>
                    <li>
                        <p><a href="http://go.microsoft.com/fwlink/?LinkId=165725">Save a file to a SharePoint
                            library or another Web location</a></p>
                    </li>
                </ul>
            </div>
            <h1 class="heading"><span onclick="ExpandCollapse(seeAlsoToggle)" style="cursor: default;" onkeypress="ExpandCollapse_CheckKey(seeAlsoToggle, event)" tabindex="0">
                <img id="seeAlsoToggle" class="toggle" name="toggleSwitch" src="../icons/collapse_all.gif" />See Also</span> 
            </h1>
            <div id="seeAlsoSection" class="section" name="collapseableSection" style="">
                <h4 class="subHeading">Concepts</h4>
                <div class="seeAlsoStyle"><span sdata="link"><a href="QualityDashboardGovDev.html">Quality Dashboard (GovDev)</a></span> </div>
                <div class="seeAlsoStyle"><span sdata="link"><a href="BuildSummaryReport.html">Build Summary Report</a></span> </div>
                <h4 class="subHeading">Other Resources</h4>
                <div class="seeAlsoStyle"><span sdata="link"><a href="ExcelReportsGovDev.html">Excel Reports (GovDev)</a></span> </div>
            </div>
        </div>
        <div id="footer">
            <div class="footerLine">
                <img width="100%" height="3px" src="../icons/footer.gif" alt="Footer image" title="Footer image" />
            </div>
            <span id="feedbackarea">Send <a href="javascript:SubmitFeedback('bjordan@microsoft.com','','','10.0','10.0.10236.10000','%0\dThank%20you%20for%20your%20feedback.%20The%20GovDev%20team%20uses%20your%20feedback%20to%20improve%20documentation.%20While%20we%20are%20reviewing%20your%20feedback,%20we%20may%20send%20you%20e-mail%20to%20ask%20for%20clarification%20or%20feedback%20on%20a%20solution.%20We%20do%20not%20use%20your%20e-mail%20address%20for%20any%20other%20purpose%20and%20we%20delete%20it%20after%20we%20finish%20our%20review.%0\AFor%20further%20information%20about%20the%20privacy%20policies%20of%20Microsoft,%20please%20see%20http://privacy.microsoft.com/en-us/default.aspx.%0\A%0\d','Customer%20Feedback');">
                feedback </a>on this topic or submit an issue at the GovDev for TFS Codeplex Site.</span> 
        </div>
    </div>
</body>
</html>